UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'huhKFiaCUbEI5tqjKW4cPxMsAaga47WFvIA32x7CEbA='
WHERE
key_id = 'c993e9fcc285b7c9dea968acc0cde586404a6d1c0fa5480e85754621f419107c'
AND (
token = 'huhKFiaCUbEI5tqjKW4cPxMsAaga47WFvIA32x7CEbA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)