UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5JonqtAWDgEI2JMVVJ3ogBx8FZmrrdwKmLUa7D9NB8Q='
WHERE
key_id = '686e395be5012edb951f4403e37aedf4464bb08a5fb824b5c09a93eee441a4a5'
AND (
token = '5JonqtAWDgEI2JMVVJ3ogBx8FZmrrdwKmLUa7D9NB8Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)