UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9m4wsH+DbeH0MS6ANA941EmAdCuzJ49YjP9X8yG2Isw='
WHERE
key_id = '4c2c11733a62f3028b3466342f0f9a793febf99a5d0365a623b6e05bce9037ec'
AND (
token = '9m4wsH+DbeH0MS6ANA941EmAdCuzJ49YjP9X8yG2Isw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)