UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LSobihUSKiji6GmPNR7PmEpFZJ+70Oyxtt7WHpETZb4='
WHERE
key_id = 'bad2e2d4d43a26900f2e1d536b6c0dfcb52e316ef813be2901a1ef49a0f22bc2'
AND (
token = 'LSobihUSKiji6GmPNR7PmEpFZJ+70Oyxtt7WHpETZb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)