UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OvX3HrY9hNhaxb411NVKgCZtcS1jeMsycKEsAossHyA='
WHERE
key_id = '5c653b9f00b34c1adf59928ef27b8743aba2dc359e75a70952eaf3dc4e1e2817'
AND (
token = 'OvX3HrY9hNhaxb411NVKgCZtcS1jeMsycKEsAossHyA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)