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