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