UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kEtLx3XRKvBgGe7do+jYg9CgncaFpyLLpEERTI+1kzU='
WHERE
key_id = 'bb8df7b4ae472271eb9493e98dd00e9b8378a24863eeee9a4f3afa93e03e3d88'
AND (
token = 'kEtLx3XRKvBgGe7do+jYg9CgncaFpyLLpEERTI+1kzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)