UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MDkX7vzSACnYG3HsrKbke6RrKzX9ctsPI4FDFJsEbNI='
WHERE
key_id = 'a9e7f1b104d13135b3c88321ed0a5b6d5179c0de1f3287ab10656ba40b8b06e6'
AND (
token = 'MDkX7vzSACnYG3HsrKbke6RrKzX9ctsPI4FDFJsEbNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)