UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mPApgWMDlR8PVojTkzaAqM+oismT1md0OLTW06zSEN4='
WHERE
key_id = '3216e0fd5857aa3eaa5ce64c25767cd98e6a2e5a894d9e1c0f9612b0ad1c6058'
AND (
token = 'mPApgWMDlR8PVojTkzaAqM+oismT1md0OLTW06zSEN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)