UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGKcfKu1yz4gEQ6YY8S3h6cs21hD4AMpOiAq/6dggVM='
WHERE
key_id = '1a018c9503f092182ea07465f062231ca778207822f0afbdf4f2733bd292c023'
AND (
token = 'zGKcfKu1yz4gEQ6YY8S3h6cs21hD4AMpOiAq/6dggVM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)