UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aT9jIeyxwV3VpkXNGElq2mglBX7jikFP6OlpBYXF8a8='
WHERE
key_id = '14e2c21c1208f5c780a1bb70137649d5f8284de8910cb30c335f1ce90dd50f03'
AND (
token = 'aT9jIeyxwV3VpkXNGElq2mglBX7jikFP6OlpBYXF8a8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)