UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xc7niZ1xKKCRPiqO+Cv/gkh+f5VErOX1/qfkDTfVVYY='
WHERE
key_id = 'b9ddd7658fe0f3b41b546ec5c315cb1100c7be1ea693a5b482da0a179c8c17fb'
AND (
token = 'xc7niZ1xKKCRPiqO+Cv/gkh+f5VErOX1/qfkDTfVVYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)