UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPHGx9P70I4DrtJmubXyZXxV/ujifF7S32XnaFpBtgk='
WHERE
key_id = 'e61d863629bdee77e8a697489eb78e1b5b2986d7cfa660695f7b670b7bfaf0fd'
AND (
token = 'XPHGx9P70I4DrtJmubXyZXxV/ujifF7S32XnaFpBtgk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)