UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nS2o/Mifu9vLpjMVpK/rakHUyTZI7MwbdIHmnyL/uKg='
WHERE
key_id = '29b6e13f94e0ffca3bad79d827d901cb702c29c1146407ab65c33199a32f6d40'
AND (
token = 'nS2o/Mifu9vLpjMVpK/rakHUyTZI7MwbdIHmnyL/uKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)