UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v3Jr/4NvhDUD09gC023jFdx07Eg0+NUiwuXioN8a7bU='
WHERE
key_id = 'd7af38ca56b714e5e5100443e9dbe5cced8c70e75edd65aa8229dae549006f8d'
AND (
token = 'v3Jr/4NvhDUD09gC023jFdx07Eg0+NUiwuXioN8a7bU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)