UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zj1vuG3weBGkY59V2JjUooLtjU4Zjcfv/o7ghonKeW4='
WHERE
key_id = 'd1e76e3cb8c3f8c0751b5ee5e2631cb28248906d44dbb3aaf669669f4fd9468e'
AND (
token = 'Zj1vuG3weBGkY59V2JjUooLtjU4Zjcfv/o7ghonKeW4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)