UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '58EFpx0lVjjL0pM6aKfJE4SLZoQHHaS18OBy3KiHsuw='
WHERE
key_id = '063ff0163a37a8167a39b5265659b29f765a9f3ac090e130148873a6a15f166f'
AND (
token = '58EFpx0lVjjL0pM6aKfJE4SLZoQHHaS18OBy3KiHsuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)