UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/TRIckTO45HYGIKiuWyhNuj8PUFsm9ULAgW+g9dDmXc='
WHERE
key_id = 'f9ce3d491649b65c6a24c398b63c97ac5bfef93bde30de6bb56b918871ea7ecb'
AND (
token = '/TRIckTO45HYGIKiuWyhNuj8PUFsm9ULAgW+g9dDmXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)