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