UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mNvBcijBoc8k5Jv0qz8bCV53BW+YodFTjQNl5R8nlG8='
WHERE
key_id = '0e8769d9c23470ed70e3bf263b8e4baa0d537bb3a848ad37c924221027ec8ac5'
AND (
token = 'mNvBcijBoc8k5Jv0qz8bCV53BW+YodFTjQNl5R8nlG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)