UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QcHrpHnCwL0WeKtWYTf60YxrS4mqHTfleuXYW6sG0cE='
WHERE
key_id = '3b66a180cff66f7d9278a12a67a48044cb9129f250de2fde09334c82898250a0'
AND (
token = 'QcHrpHnCwL0WeKtWYTf60YxrS4mqHTfleuXYW6sG0cE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)