UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6l8JaVDAwWTMoGfkiLFcv+kpFGMF5J49/F0nzxkJUyc='
WHERE
key_id = '53d5b28952f58bfa2a7f777d54ea2963977dce376389a3f553c966718f9aee8b'
AND (
token = '6l8JaVDAwWTMoGfkiLFcv+kpFGMF5J49/F0nzxkJUyc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)