UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm4wUMWRxh7fqNrYw42genWDMGmgG6sSDl7bsnF3RK8g='
WHERE
key_id = '8214679cf3368a7351b50663c0bd5ce1a25240ef7144e133b0c6160dc744faeb'
AND (
token = 'm4wUMWRxh7fqNrYw42genWDMGmgG6sSDl7bsnF3RK8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)