UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ji0Luwhf3h528yx/rLPG0AYE1Pc9n0JESq64/M9lrrE='
WHERE
key_id = '39a876bcf8caf07a2760ee17229ff846e363dce0de0d4ceb16aa8a8f6a283a53'
AND (
token = 'ji0Luwhf3h528yx/rLPG0AYE1Pc9n0JESq64/M9lrrE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)