UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dMc/BBmW7jjbhAE3lflXB2VnmFmCBsG5yO4uMGxBJ/A='
WHERE
key_id = '9ba30e0233400f0aaeebab84e851e92d5d4ed5af9d222576c0029b07d9c8de30'
AND (
token = 'dMc/BBmW7jjbhAE3lflXB2VnmFmCBsG5yO4uMGxBJ/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)