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