UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZssHqd5yhSA090cvURlZDiLnhaPXHGHbfJoGMHHQkrU='
WHERE
key_id = 'be2eadbcd45936c67e94c9a59c9ffe211cda1a4ec33e4262cf00e53a51397104'
AND (
token = 'ZssHqd5yhSA090cvURlZDiLnhaPXHGHbfJoGMHHQkrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)