UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FHIRKy1gl5RfW4+hQe2VLHR0TEeoRGcd3R7op4HFUrA='
WHERE
key_id = '8da2970a23677f58bc3134003827b492512d567d150ded530969eab9b48f3077'
AND (
token = 'FHIRKy1gl5RfW4+hQe2VLHR0TEeoRGcd3R7op4HFUrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)