UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNT3n7MxNb8bDyqg3QQHDuNg6iixVu5N/8DaEvQmzKE='
WHERE
key_id = 'be0cb40c6722c54ab5a63e52b68b23e95d8956807aab50c4aa6a8f2a6d1ac9da'
AND (
token = 'zNT3n7MxNb8bDyqg3QQHDuNg6iixVu5N/8DaEvQmzKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)