UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZCaavzhnXjmi6Gs/4FJ4n4HNnfUTKjmma78JxWR+HVM='
WHERE
key_id = '030845437c68a39b62f367aa0c4d784ec82e9cc90a51dc03a7df42eae4ea1dd1'
AND (
token = 'ZCaavzhnXjmi6Gs/4FJ4n4HNnfUTKjmma78JxWR+HVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)