UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XCfjrbcRiwj3Tjv+KWSteUH7n7aWITNyzRK/+kXT0Xw='
WHERE
key_id = '149437d6a297e394965e0a2e99b216e12b53ebdaa3175bb1772e03f7afe96b4a'
AND (
token = 'XCfjrbcRiwj3Tjv+KWSteUH7n7aWITNyzRK/+kXT0Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)