UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zNXjuauNsvjIsv8NULeHKu9mMLfdTPzkBZ4oqV1BgVM='
WHERE
key_id = '9a519e453f591d19c2db21bccf761ec9c3bf2387388f63093350d62385b75714'
AND (
token = 'zNXjuauNsvjIsv8NULeHKu9mMLfdTPzkBZ4oqV1BgVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)