UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ES30c40MC4PhZPIXNGKwX3hWD1EOmQTG1kCqsjCRq8U='
WHERE
key_id = '682d6658ea8ea774b2ae7a9316d807719f6f678c936d77913d71566ddc3fa8d6'
AND (
token = 'ES30c40MC4PhZPIXNGKwX3hWD1EOmQTG1kCqsjCRq8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)